USE[DeltaFlex]
GO
IF(OBJECT_ID('dbo.sp_CercarOTByIdOT')IS NOT NULL)
	DROP PROCEDURE dbo.sp_CercarOTByIdOT
GO

CREATE PROCEDURE dbo.sp_CercarOTByIdOT
	@IDORDRE INT
AS
BEGIN
	SET NOCOUNT ON
	SELECT *
	  FROM DBO.ORDRE_TREBALL 
	 WHERE IDORDRE = @IDORDRE
END 
GO